The CICA Windows Explosion!

home *** CD-ROM | disk | FTP | other *** search

/ The CICA Windows Explosion! / The CICA Windows Explosion! - Disc 2.iso / access / accu22.zip / ACCESS.LST next >

Wrap

File List | 1994-12-01 | 133KB | 1,842 lines

Page No. 1 12/01/94 PD/Shareware Products in Library Release Date Product Description ** Type Applications 06/30/94 Education registration system with extensive user manual (in WordPerfect file format). ** Type Buttons 06/03/92 Animated button control which moves a green light back and forth when pressed. CCB file for use with the Professional Toolkit. 11/20/94 Simple, but useful set of "always on top" control buttons that float at the top of the screen. You can always change the caption on each button and add "On Push" functions (macros) of your choice by opening FORM HelpButtons in design view. ** Type Clock 02/15/93 Clock, shows time/date in programmable formats. Monitor memory, resources, disk space, printing. Display tree/moon graphics showing seasons, moon phases, night/day. Dial the atomic clock. Play hourly sound. Etc. Source code included. ** Type Database Design 02/26/93 Shows how to create a 3D raised or embossed effect using standard label controls. Step by step instructions. 12/26/92 Business and personal address book database. 02/09/93 Plus-in calendar data-entry tool and sample. Source embedded includes information on calling CAL from any app. Once a date is selected, the value is returned tot he calling program. 12/23/92 Database of crafts-related information on books, videos, authors, magazines, suppliers, etc. Features combo box embedded subforms and many queries and reports. 01/18/93 This database includes an example of validating a record on a form by making sure all fields have an entry. 03/28/93 Uses stocks as items and is programmed to offset trades as they are posted to a posting journal from a transaction table. 02/17/93 Four design tools: Form Design Tool Palette Macro to Module Converter Extended New Procedure Dialog Menu Builder. 12/09/92 Database includes sample code for graying menu items. 01/27/93 Dll for Access Basic which allows Access programmers to programatically manipulate table definitions and data relationships. For example, this DLL allows Access Basic to create tables directly. 01/11/93 Replacements for UTILITY.MDA and WIZARD.MDA offering new tools for your toolbars and adds color to existing tools and offering different graphic arrows for Wizard screens. 12/21/92 Sample shows how to store pictures outside a database by pointing to them with a file name instead of storing the picture in the table. 03/19/93 Early version address book/day planner/task manager, a Page No. 2 12/01/94 PD/Shareware Products in Library Release Date Product Description basis for further work. 02/17/93 Companion PROMPT.MDB for the Microsoft Press book "Running Microsoft Access". An order entry/inventory app that's automated almost entirely with macros. Text file describes enhancements and corrections to book since publication. 06/11/93 Utility to compact or repair Access databases without needing to run Access. 06/11/93 Utility to change or maintain settings in the MSACCESS.INI file, such as alternate system library databases, wizards, buffer size, read ahead pages, and more. 04/20/93 Electronic magazine covering the Basic language. This issue includes Microsoft Knowledgebase articles covering "Creating Custom Wizards with Access Basic". 05/18/93 Database for bicyclists to monitor training sessions. Previews and prints Month Summary and Year-To-Date Summary. Access source code. 04/12/93 Small database with a form demonstrating the use of shadow controls to simulate dBASE "Set Carry On". 06/17/93 Application for tracking changes to software source code using a log, file, and program id concept. Uses two subforms on a master form allowing the viewing of a one to many file structure to be viewed, edited, and added. 04/27/93 Example of how to let user insert records in any desired order. 06/03/93 Discusses approaches and implications of using separate code and database MDB files. Access Basic code included. 05/17/93 Four sample applications for Access. MSCMS - graphical contact manager and diary MSSWEETS - inventory control and order processing for a candy store MSDIRECT - directory of Access add-on products MSFORMS - various forms including Invoice, Expense, etc 10/30/93 Database to manage personal and business contacts while maintaining historical contact data. 06/13/93 Contact manager / personal information manager that uses Access to provide address management, task management, a Hot List of frequently called numbers, a reminder of upcoming important dates, etc. 04/26/93 Sample insurance prospect/client management system. Demonstrates multiple subforms and use of queries. 06/08/93 Database prints multiple labels per record. Includes queries and Access basic code. 05/06/93 Form like those used is Wizards where user selects items from one list and places selections in another. ">", "<". ">>". "<<" buttons move items from one box to the other. Includes Access Basic code and good documentation. 03/31/93 Two popup forms that allow you to copy and paste field names as you write macros or code. 05/29/94 A church database that handles pledges and donations, membership, and group attendance. 05/30/93 Food Pantry database. Can look up clients using ids or Page No. 3 12/01/94 PD/Shareware Products in Library Release Date Product Description first or last name. Lookup match can go to client's data record, with personal info and records of past visits. 05/31/93 Contact manager using autodial, barcodes, and much more. NO DOCUMENTATION. 04/01/93 Audio tape labeler and catalog. Prints cassette and R-DAT labels. Requires Adobe Type Manager and 800x600 Windows resolution. ATM fonts included. A 1.2 version is available for $20 from the author. 04/27/93 Replacements for UTILITY.MDA, featuring new buttons for the Access toolbars. Version for VGA resolution only. SuperVGA version is TBAR5S. 04/27/93 Replacements for UTILITY.MDA, featuring new buttons for the Access toolbars. Version for SuperVGA resolution only. VGA version is TBAR5V. 04/27/93 Modified version of UTILITY.MDA which expands the Access color palette. 05/12/93 A complex but incomplete Video Store Database including customer accounts, inventory, etc. This file has been used as a Microsoft demonstration of Access. 08/09/93 Sample buttons for use with Access forms. BUttons may be copied as needed demo of registered version containing over 600 buttons and images. 08/08/93 Extensive database design for cataloging audio CDs. Forms and techniques used may be copied into other programs. Includes forms for data entry of CDs, composers, performers, categories and types. 08/24/93 Text file (Microsoft Word for Windows format), "Microsoft Access Naming Conventions and Style Guidelines". Discusses Naming Database Objects and Controls Modules-What Goes Where Designing A Function Procedure Adding Comments and Documenting Work etc. 08/29/93 Demonstrates how to insert a new blank line at the start of a memo field and stamp the current date to a memo field. 08/06/93 Example address book with a Grateful Dead theme (buggy). 08/18/93 Simple address database features category filtering and graphics. 12/09/93 Simple diskette label program with WYSIWYG features to show you how it will look on a 3.5" diskette. Designed for use with Avery labels style #5196. 07/24/93 Database inspired by Jimi Hendrix, features sample Hendrix-related entries. Features filtering on alpha characters, report generator, time, and hidden controls. 08/10/93 A set of suggested naming conventions for Access programmers. 08/08/93 Examples of a technique for rearranging data. Two functions: one parses equal length data into separate columns the other simulates multi table unions. 09/06/93 Database of NFL games for 1993-94 season. Search by team Page No. 4 12/01/94 PD/Shareware Products in Library Release Date Product Description or date. Excellent graphical design. 08/22/93 Database for classical recordings. Uses update able combo boxes for fast adding of records. 07/15/93 Example of using subforms and queries to create a summary report of multiple medical symptoms from a single table listing symptoms by patient ID. 12/14/93 Program to add/delete/change/edit the tables, fields, indexes, relations, and query definitions for a VB Access database. You can measure performance and print the dictionary of your database. 08/29/93 Will print the field and index definitions for any Microsoft Access database. 11/10/93 Example shows how to control the color of a text box based on the data it contains. 11/14/93 Sample database shows an alternate method for using dynamic menus within forms. Uses only small macros. 09/24/93 Library simulates the VCR buttons and record position indicator of the horizontal scroll bar without the scroll bar. Also adds a field to indicate the number of total records. 03/18/94 Database designed for Princeton University's outdoor education program. Stores a variety of information including: mailing lists, staff records, trip information, library inventory, and accident records. 10/01/93 Unfinished resource management system for a projects-based company. Handles companies and projects, invoice and revenue logging. 10/20/93 Database of North American bird species. Shareware version includes 100 species registered version over 700. 09/26/93 WYSIWYG authoring tool for Windows Help Files. Uses Drag and Drop, supports bitmap and sound files. Requires VBRUN300.DLL. [And could use a grammar check all through its own documentation but the program is sound.] 08/25/93 Database of City/State/Zip codes, and sample Access program to automatically fill city/state from the ZIP code. Current database available upon registration. 04/09/93 Personal Information Manager "Managing an Extensive Amount of Personal Information". 01/25/93 Menu Wizard helps in creating menus in Access. Not supported by Microsoft. 11/07/93 The functionality of "Post-It Notes" (R) implemented inside Access. Includes article with complete details in MS Word format. Allows user of your application to leave notes on aform, having them become visible when returning to the form. 10/04/93 Spell Checker DLL. Example programs in C++, Pascal, and Visual Basic included, easily adapted to Access Basic. American and British versions available. 09/16/93 Organizes local listings of 12-step self-help programs. 01/20/94 Complete automated application for managing attached Access tables. Very useful when code and database are in separate MDB files. Page No. 5 12/01/94 PD/Shareware Products in Library Release Date Product Description 01/05/94 Utility for Visual Basic developers to create help files using Access. Imports project files into Access database, allowing scripts to be written for each control containing text, popups, and jumps to other contexts. 01/02/94 MDB database and module code illustrates how to enter a ZIP code and have Access look up and fill in the city and state. Sample ZIP codes are numbered from 63000 through 69367. 12/21/93 Shows how to make explicit selections from a list of records so that specific actions can be carried out. In the example, using a table containing names of hotels, you can select for which hotels to prepare envelopes. 12/09/93 Access Basic function adds random records to any table. Performance Testing utility takes the table name and the number of records to be added, then creates random records. 11/26/93 Replacement for the Access Toolbar. Simple modification of UTILITY.MDA that utilizes new command buttons which call Access basic functions that perform the DoMenuItem command. 03/06/94 Sample of how to allow a user to easily maintain combo-box lists using an AutoUpdate feature. "Preferences" feature allows combo box setting of Automatic Update, which updates the list of values automatically when a new value is entered. 03/04/94 Sample application for a company that provides maintenance to equipment with direct billing or contract basis. Log on as "Ken Golding". Menu driven and demonstrates many features of Access. 02/28/94 DEMO of database analyzer designed to help create applications free of errors, omissions, and inconsistencies. Analyzes and documents tables, queries, forms, reports, macros, and modules. Shows summaries designed to make problems stand out. 02/15/94 Database for users of applications to comment and initiate improvements to other applications. 02/14/94 Access Wizard allows you to format and paste in a code framework for writing functions that follow a certain format. The Wizard allows you to look at the code before inserting into a module. 02/12/94 Simple Access object listing utility. Contains table for defining the object codes, a query for indexing the objects, and a report. Simply import these objects into an existing database and print a report. 02/09/94 Automates the task of presenting a questionaire to a group of networked users. Written to look for data files on four servers. Graphs the information collected. 01/31/94 Form includes conversions from hex to decimal and hex to decimal. 01/28/94 Menu add-in utility to display the last date of change of the database, and in descending order, the date of the last update and the date of creation, separately for each database object. Page No. 6 12/01/94 PD/Shareware Products in Library Release Date Product Description 01/26/94 Demo of a software development kit to provide Contact Management for developers. Unlimited contacts, unlimited addresses, unlimited phone numbers source code provided (with purchase) contact transaction history DDE links to Word, Mail, Schedule etc. 03/20/94 Application (parts unfinished) which keeps track of employees and what they do by work type. Workers have codes attached and are organized under categories. A good starter framework for additional customization. 03/21/94 Program to produce a hardcopy printout of Microsoft Access table structures, including field descriptions. Tested only with Access 1.1. Requires VBRUN300.DLL. VB source code included. 04/10/94 Printer control/capture via single icon/hotkeys/menu. Send screen, window, client, rectangle or clipboard to printer, clipboard, file, or fax. Print files. Load files to clipboard. Change orientation. 04/01/94 Demonstrates the use of hidden controls to create a 12 tabbed dialog box, which rotates the rows as you bring a tab to the front. Similar to Word 6 and Excel 5. 04/08/94 Documents outstanding work required on forms, controls, reports, etc. A report of your notes may be printed for review. Tracks database, user, object name, and more. Great way to get end-user feedback. 07/06/94 General library of functions. Includes Attachment Manager for managing attachments to external databases functions for accessing Common Dialogs creating an Error Table of Access Errors pop-up calendar for editing dates string functions. 06/26/94 Database for a college wilderness orienation program. Includes participant application tables, leader tables, trip information tables, extensive queries and reports. 06/22/94 Database for tracking components of assemblies. Includes bill of material report. Select a component from a combo box and see all assemblies where that component is used. Easily extensible. 06/21/94 Text file containing intrinsic constants that can be used to set ForeColor, BackColor, and BorderColor to use Windows system colors set by the user. Includes Access Basic and Visual Basic versions. 06/20/94 Set of procedures to sort records following a personal order in a listbox or tabular form. 06/17/94 Application for tracking changes to software source code using a log, file, and ID concept. Uses two subforms on a master form allowing the viewing of a one to many file structure to be viewed, added, and edited. 11/14/94 Find and Replace for Tables, Queries, Forms, Reports, Macros, and Modules. Can locate all occurences of a given function. 07/06/94 Creates a schedule for an unlimted number of people. Page No. 7 12/01/94 PD/Shareware Products in Library Release Date Product Description Allows multiple groups of people to be scheduled. Schedules Holidays and Vacation days, picking employees in rotation for weekend schedules. Protected database unprotected version available with reg. 06/29/94 Simple purchase requistion system. Features: entry of requistions to a database file for software, hardware, and other purchases ability to print requistion from entry screen lookups of old or outstanding requistions. 06/14/94 Example database using OCX Multiselect List Box, requires OC1016.ZIP and MSLB.ZIP OCX controls. For Access 2.x only. 08/18/94 Billing/invoicing system. Tracks sales and payments, prints invoices and month-end statements. Stores prices for each item for each client, enabling custom pricing for each client. 06/08/94 Add ToolTips just like Microsoft's. The ToolTips are based on a mouse_move event rather than a Click event. 06/03/94 Add ToolTips similar to Microsoft's. ToolTips in this file are based on right mouse click events. 06/03/94 Text file, ASCII format, "Microsoft Access Naming Conventions and Style Guidelines". Discusses Naming Database Objects and Controls Modules-What Goes Where Designing A Function Procedure Adding Comments and Documenting Work etc. 6/94 revision. 06/02/94 Prepares Windows Help files. Translates ASCII text into RTF files. Sets up a button bar to run your text editor, the translator, and the Help Compiler. 05/14/94 Database demonstrates a technique for generating pedigrees using a self-referencing table. The relationship of an indivisual to his parents is all that is entered the rest of the pedigree is generated by the program. 09/03/94 Tool tip library contains all the code needed to complement floating tool tips (toolbars) on buttons or on any control. 08/24/94 Database contains the 1994 NFL schedule. You can enter the scores and the database keeps track of rankings. 08/23/94 Database to manage client contracts, proposals, and billings for small consulting firms. 08/22/94 A debugging tool as a Wizard. Tracks, saves, and prints Events, Functions, and Subroutines. Uses OLE to link to Word for Windows. 08/07/94 Table maintenance utility provides developers with an example of a user-freindly front end that enables the updating of many-to-many tables. 08/05/94 Timecard program to track hours worked on a project. Handles multiple projects and includes a printed timesheet by week and a sample invoice. 08/02/94 Assists developers with a common core architecture for Access 2.0. Includes standard Basic modules that provide application specific formats. Features 36 menu options Page No. 8 12/01/94 PD/Shareware Products in Library Release Date Product Description Menu generator Generic report writer example of many-to-many table maintenance etc. 07/25/94 Utility for entering dates. Several date formats are supported. Copies dates to the Clipboard. Use included macros to automatically paste selected dates into Word, Excel, Access, or Visual Basic programs. 07/25/94 Sample program for use with Clip Calendar. See file CLIPCA. 05/27/94 Order Processing application. Quarterly shipping schedule uses modules at query level to solve the problem of overlapping weeks at year-end. 02/07/94 Library contains functions to call API functions, prevent users from doing certain actions, modify the Access main window, call the Access progress-meter and create 3D effects. 01/17/94 Database allows you to enter and retrieve the data from CD recordings along with information about composers in an easy way. 09/08/93 Academic reference database written in German. Full indexing and search capabilities for articles and books. 08/08/93 Reference database for books and articles. Can hold up to 32K notes per record. 02/20/93 Finish Line automatically learns the words and phrases you use, allowing you to finish a line with a single keystroke. Works with any Windows textual application. 01/25/93 Wizard which adds easy menu programming to Access. 10/28/94 Field archiving database - records Field Name, Value, and Time field was changed. Parses, replaces old values, and stores in Modify field. 10/27/94 Customized table-driven MsgBox/InputBox system. A dialog box is used to create new messages and write corresponding Access Basic code which can be paster into the Module window. 10/21/94 Complete revision of the ANALYZER.MDA wizard from Access 1.x. Relies on Data Access Technology in Access 2.0 to analyze objects and properties to analyze. Reports the organization, structure, and settings of a database file. 10/11/94 Provides on screen documentation of an Access 2.0 database. You can select the type of object and the specific objects to be analyzed. The properties of the analyzed objects are displayed in a data outline control. BETA release. 10/09/94 Contact database with call tracking, follow-up reports, meeting data, etc. Many useful forms. 09/30/94 Database developed to run a fantasy basketball league. Contains NBA player data for 1992-1994. Includes tables, queries, forms and graph styles. 09/30/94 Basic interface and system monitor for Access 2 only. A framework starter application. 09/26/94 Easily creates sample data to test applications. From 1 to 1 gazillion records can be generated, in ASCII format Page No. 9 12/01/94 PD/Shareware Products in Library Release Date Product Description matching intended actual data, for import into Access or any database. 09/24/94 Complete 1991 US Department of Labor Dictionary of Occupational Titles. Contains job titles, DOT codes, worker trait profiles of all DOT job titles. Numerous queries and forms useful to a career, vocational, or guidance counselor. 09/23/94 Application shows how simple parent/child (assembly/component) relationships can be used to develop multi-level bill of material structures for reporting and costing. 09/17/94 Application allows the user to enter the foods eaten in a day, then looks up the nutritional value from a table, and displays calories, protein, fat, and carbohydrates for the food item and the total for the day. Subform is used to group records by date. 09/16/94 Access add-in for helping build Data Access Object syntax. NOT supported by Microsoft. 09/07/94 Database documenter allows you to choose from all the objects in the database and document them. Brief concise documentation. ** Type Forms 01/28/93 Program which shows available colors, then pastes the chosen color into the color property. 02/09/93 Free calendar form. Call the calendar function with any date and the appropriate month will be displayed. User can press a button on the day square and the selected date is returned to the application. 12/28/92 Provides routines for manipulating Access forms and windows through the Windows API to keep a form centered on any display. 01/06/93 Program to visually select a color by using slider bars. An RGB value is shown which can be copied to the clipboard for pasting into the color properties of a control on a form. Requires VBRUN200. 02/19/93 Modified version of Order Entry database form showing an implementation of a record counter which mimics Access's horizontal scroll bar. Allows entry of specific record numbers. Macro and module included. 02/09/93 An example of getting data from the previous record when the current record is a new unsaved record. 01/15/93 A wizard that guides you into creating a domain function for your query or form. (Examples of domain functions are DLookUp, DSum, DAvg, etc.) 03/30/93 Database as an example of how to use to code to apply filters to a form. A single form with three unbound controls in the header is used to create a SQL string which is used as the argument to the ApplyFilter action. 12/15/92 Example database showing how to relate multiple subforms. 12/19/92 A solution to relating multiple subforms. This version uses a combo box and uses a normalized relational schema. 03/26/93 A example of a modal popup form that lists all current Page No. 10 12/01/94 PD/Shareware Products in Library Release Date Product Description objects in the database and allows you to filter them if suffix naming conventions were used. 03/08/93 Designed to add a blank row to a listbox or combo. A library database containing an Access Basic function that fills a listbox or combo from a table/query, adding a blank row at the top. 02/18/93 Access Basic code to move and size a form. 02/06/93 This example shows how to allow editing on a form without also allowing new records to be added. 01/18/93 Example of faking a multi-selection list box. 01/04/93 Example shows how to do multiselect listboxes. Uses SQL to fill listboxes, a table, and autoexec macro. 01/11/93 Shows how to simulate a Windows spin button. Lets you easily increment or decrement a date or numeric field by pressing and holding the mouse button on the up arrow or down arrow portion of the button. 03/26/93 Synchronize recordset with listbox and subform in a form. 03/06/93 New buttons for the Access toolbars (Print, Save, Object Align and others). 03/24/93 Places the Date, Time, and Free Resources on the Access Title Bar. Also includes a quick exit button. 04/30/93 Database demonstrates how to move between forms with "Next >>" and "Previous <<" buttons. 05/16/93 Demonstrates how to change the record source of a form, so the same form can be used with multiple tables. Achieved with the ApplyFilter macro. 05/25/93 Dialog with VCR controls allows the user to navigate through a series of related data entry screens. Shows how to create forms like those of Access Wizards. Example database includes Access Basic code and good documentation. 02/17/93 Simple example of spin buttons. 01/20/94 Example database shows how to create a combined text/combo box. When you enter the text box, it becomes a combo box, when you leave it, it switches back to text box. 01/18/94 Two samples of animated buttons that feature a cartoon-like animation. 01/06/94 An example of synchronizing a form and subform using a Combobox, in addition to the VCR buttons supplied by FormWizard. Advanced methods are used to move the record pointer in the child table displayed in the SubForm. 11/23/93 Self contained utility which allows custom-designed InputBoxes, complete with demonstration. Has the advantage over forms in that it waits for user input, and suspends the macro, just like InputBox - yet it uses ordinary forms for the display. 03/11/94 Tool allows you to open a form with one or two mouse clicks. Useful if there are more than three forms in an application. 02/23/94 Demonstration of how to open and close several screens from one option group. Uses a short Access Basic routine involving the "Screen.ActiveForm" property. Page No. 11 12/01/94 PD/Shareware Products in Library Release Date Product Description 06/20/94 Toolbar provides quick access to design tools buried in Access standard menus. Also replaces most form design toolbar buttons. Includes buttons for toolbar, toolbox, palette, property sheet, field list, ruler, grid, status bar, design view, etc. 02/09/94 Small database stores some standard (boilerplate) letters, and lets the user personalize and create custom letters. 02/08/94 Short Access Basic subfunction changes the title bar of the active form via program steps. 01/27/94 Sample shows filling VendorID, month and year of order and the number of orders placed with a vendor in the month, in addition to a standard counter field. 04/12/94 Sample of how to synchronize a form's record detail with the chosen selection list's record. Selection list is displayed at the top of the form, while record detail is displayed at the bottom of the form. 04/03/94 Text Handling module contains three functions which can be used in the properties of a text box: All_Caps(), Cap_All_First() [forces first letter of each word into uppercase], Cap_first_Letter() [forces only the first letter of a word to uppercase]. 03/28/94 Simulates programmable TAB controls on forms, such as those found in Excel 5 and WinWord 6. 03/28/94 Calendar form that can be called by Access or Visual Basic. Access and Visual Basic source code included. User can click on a date on an Access form and then edit that date on the KFCAL form with a single mouse click. 07/01/94 Database contains an "About" form which can be imported into your database using "File/Import". Self-contained. Includes copyright notice Windows mode (standard or enhanced) free memory if a math coprocessor is present and free system resources. 06/21/94 Example of resizing controls on a form with code. Two example forms show manual and automatic resizing of various kinds of controls. Source code is commented. 07/08/94 Tab OLE Control for Access 2.x. Tabbed user interface. SpecialEffect Normal or Raised tabs can be located on left, right, top or bottom Tab taxt can be rotated 0,90,180,270 degrees tab body can be open or closed etc. 07/08/94 OLE Custom Control for Access 2.0. The control is basically a label which can be rotated 0, 90, 180, or 270 degrees. 07/08/94 OLE Custom Control for Access 2.0. Provides a multiselect list box like the one provided with Visual Basic. Features: Methods, Properties, and Events similar to VB list box single select, simple multiselect, or extended multiselect AfterStartup event. Page No. 12 12/01/94 PD/Shareware Products in Library Release Date Product Description 06/10/94 Demonstrates a way to move/resize form controls at runtime, using the mouse. From "Access How-To" from Waite Group Press. 08/19/94 Example of changing one control type to another on a form - for example, changing a text box to a list box. Once you select a control, you can specify what type of control to change it into. 06/03/94 Sample form with map of the United States. Click on a State and find the number of engineers or customers for that State. 05/27/94 Alternate color palette for Access 2.0 with 99 colors. BackColor or BorderColor for a control or form can be set. 05/27/94 Replacement for the Access Zoom Box. Has buttons to selct font size, type, and color. Settings are remembered from session to session. Full source included. 05/23/94 Module adds drag and drop capabiliy to forms. Set the mouse on the "from" control, press the left mouse button, then move mouse to the "to" button. The functions will move the "from" control content to the "to" control content. 05/23/94 Module produces a 2x Zoom function in form and report design. 05/18/94 Library changes the color of a form while in form view. You can choose from a list of open forms. Provides a way to view dithered colors on loaded forms. 01/28/94 Demonstrates how to check/uncheck/enable/disable menu items affecting all opened and unopened forms. Access Basic modules. 09/07/94 Form shows the current system date and time and allows changing them. 08/24/94 Replacement for the Access function that checks to see if a form is loaded. This faster method tries to set a test variable to the visible setting of the given form, instead of looping thru all loaded forms. 09/24/94 Generic method to zoom into any control on an Access form. Also includes parsing routines and other routines. 07/23/94 Custom counter function generates the next available number to be used in a counter field. Replaces the Access Counter. (The Access Counter does not reutilize numbers when a record is deleted and may jump over a number if a partial entry is deleted.) 11/06/94 Database includes a form, SQLScratchpad, which can be used to execute SQL statements and view the results on the same form. 11/01/94 A simple Time Clock application. 11/20/94 Small MDA utility file provides a convenient method for creating or modifying Access 2.0 module coding of "DoMenuItem"s. Quickly find the proper code out of over 745 and places the code in the module window. Demo version does not include all 745 codes! 11/10/94 Application controlled referential integrity for combo boxes. Source code unprotected. [Seems to be incomplete.] 10/12/94 Access database code to save and restore the Access Page No. 13 12/01/94 PD/Shareware Products in Library Release Date Product Description window size and position. 10/09/94 Designed to add a blank row to a listbox or combo. A library database containing an Access Basic function that fills a listbox or combo from a table/query, adding a blank row at the top. Modified from LISTFN for use with Access 2.0. 09/14/94 Sample database and documentation describing a way to create Multi-Select Option Groups in Access. This method allows you to choose as many options as exist in a group. 09/12/94 General purpose form for getting a date range. Uses an interesting interface by implementing Date Intervals and applying Prior, Current, and Next scopes to the From and To date fields. Uses MSACAL20.OCX and MSASB20.OCX. Small code changes without those.. 09/12/94 Sample code to Tooltip enable a form. Uses a pop-up form instead of a text box so tooltips are not restricted to the size of the form. 08/30/94 Add-in utility for adding Tool Tips to your Access applications. Unlocked source available for $20 registration. ** Type Graphics 10/15/92 Carl Franklin's ANIMATE code and bitmaps from 'creating Smooth Animation with Visual Basic', BasicPro magazine, Oct/Nov 1992. 03/30/93 Video for Windows demo. All source code included. Plays AVI, files, and plays and records WAV files. ** Type Import/Export 12/02/92 Basic CompuServe message tracking application. 12/11/92 Text file containing a MS Knowledgebase article which discusses how to copy a DOS file using Access Basic. 09/02/93 Update of the Btrieve ISAM driver for use with Access 1.1. 07/29/93 Utility program to format a long SQL statement so it can be assigned to an Access Basic variable in small chunks. 12/09/93 Library intended to speed up the process of exporting and deleting large numbers of database objects. Useful in multiuser environments. 10/26/94 COMPACT.EXE can be used to compact or repair Access databases without running Access. Convenient for users using runtimed applications without the full version of Access. 10/02/93 Exports the result of a query to an ASCII file. Documentation within module. 10/12/93 Module to read a GEDCOM (genealogy) file and insert the data into the fields it creates. 09/29/93 Module calls a DOS program but takes back control after a specified time period, terminating the DOS application. 01/20/94 Not sold or supported by the author. Unofficial document describes using Btrieve files with Access. Microsoft Word 6.0 format. 12/16/93 Utility to condition comma delimited ASCII files for importing into MS Access, by "doubling-up" any Page No. 14 12/01/94 PD/Shareware Products in Library Release Date Product Description double-quotes (") imbedded in fields in the import file. 12/04/93 Utility completely rebuilds an existing MDB into a new one. The new MDB will contain all objects of the source MDB, including any relations within tables. Applications include changing the ownership of the MDB, cleaning security and repairing damage. 02/15/94 Database provides examples of how to import large fixed-width or Comma Separated text files using Transactions, to avoid Maximum transaction limits in Access 1.x. Provided by Microsoft without support. 02/12/94 Sample program/database and detailed explanation of how to import large amounts of data from a flat-file mainframe database and place it into tables manageable by Access. 03/28/94 For Access 2.0 only. Maintains multiple copies of the same database with different attachments. Holds all info in tables and INI files. 05/09/94 Applies the Table-related Datasheet properties from Access 1.x databases to the corresponding 2.0 databases. These properties, such as RowHeight, FontName, and others, are not converted properly by the Access 2.0 Convert Database command. 09/28/94 Utility to compact and repair Access databases. Delete databases, encrypt or decrypt during compact select single or multiple databases in same directory. Visual Basic Source code available with registration. 07/11/94 Security Conversion Wizard converts a V1.x SYSTEM.MDA file and supporting databases to V2.x format. NOT supported by Microsoft BETA VERSION. 05/27/94 COMPACT.EXE can be used to compact or repair Access databases without running Access. Convenient for users using runtimed applications without the full version of Access. This version will compact any Access database to Access 2.0 format ONLY. 08/28/94 Small MDA that generates random records for testing, then can delete them. 10/15/94 Library allows you to export objects, tables, forms, reports, macros, and modules from one MDB to another, based on each object's last modified date/time and the cutoff date/time that you specify. ** Type Information 01/15/93 Listing of issues concerning Access. Issues which contain a number "Q#####" in the header have been confirmed by Microsoft and are documented in the Microsoft Knowledgebase (see file ACCKB). Other issues are under investigation. 03/19/93 List of problems that may occur when using Microsoft Access. Bugs and workarounds. 11/15/92 Text version of the original Microsoft Access press release data sheet. 11/15/92 Original Microsoft Access Press Release in Word 2.0 Page No. 15 12/01/94 PD/Shareware Products in Library Release Date Product Description format and TXT format. 03/17/93 Announcement of developer training for Access for professional developers and consultants. 01/22/93 Quarterly electronic magazine. This issue contains a review of Access and announcement of Access training services from Xerox and more. 03/05/93 Information on Access and FoxPro Developer programs, part of the Microsoft Developer Network. 12/14/92 A text file, "Microsoft Database Backgrounder", which explains the differences between Access and Foxpro, and explains how ODBC works, in Word and Write formats. 12/28/92 A text file containing a list of Access Basic error messages sorted by error number. 12/17/92 Microsoft's official response to an unflattering article about Access in Infoworld magazine. 11/15/92 Guide to using the Microsoft Knowledgebase on Compuserve, the most up-to-date collection of technical articles about Access 03/10/93 Open letter from the Microsoft Access team to all Access customers. Printed in Infoworld, PC Week, etc. 02/24/93 Information on Pinnacle's new magazine for Access and its editor-in-chief. 03/10/93 Frequently asked questions and answers for Access database version 1.00, compiled by the Microsoft Access Product Support team. 03/19/93 Information about the Access Runtime Distribution Kit. 09/30/93 Word and TXT file describing the network security features contained in Access. 01/13/93 Access database with all known Authorized Training Centers doing training about Access. 03/31/93 RTF format text files containing the outlines of four Access courses offered by Meliora Systems. 05/17/93 Article intended for the developer familiar with dBase but new to Access. Some of the key differences between dBase and Access are discussed. Microsoft Word file. 06/03/93 Microsoft press release announcing Access 1.1. 03/05/93 Information about Microsoft Access and Foxpro Developer SIGs and the Microsoft Developer Network CD-ROM. 08/22/94 All Microsoft Knowledgebase articles (as of date of file) compiled in Windows Help format. Version for Access 1.x. Not on diskette library (too big). 09/03/93 Listing of books about Access. 08/10/93 Word for Windows document describes using the Microsoft Jet Database Engine with ODBC data. 08/28/93 Listing of Visual basic and Access books, publications, information services and conferences. From Visual Basic Programmers Journal. 03/21/93 How to see the secret credits screen and gag contained in Access. 02/14/93 Miscellaneous text files from the Microsoft Knowledgebase concerning Access. 09/17/93 Magazine in Windows Help format concerning Access. Contents include: New Access Products, Reviews of Page No. 16 12/01/94 PD/Shareware Products in Library Release Date Product Description shareware and commercial products. 01/01/93 Access database containing instructions and tech notes concerning Access. 11/11/93 Text file of common questions and answers concerning Access Tables and Database Design. 02/18/94 WinHelp file contains information on support services offered by Microsoft. 06/23/94 List of Visual Basic and Access books, publications, information services and conferences provided by Visual Basic Programmer's Journal. 02/02/94 Magazine in Windows Help format concerning Access. Contents include: New Access Products, Reviews of shareware and commercial products. 04/18/94 Not sold or supported by the author. Frequently asked questions about Access. Includes comparisons to other databases, Access Basic tips, tips on all aspects of Access. 03/02/94 Keyworded cumulative index database to "Smart Access" magazine through 3/94 issue. Can be browsed or searched to get an idea of the magazine. 03/31/94 Windows Write file reviews the new and enhanced features of Access 2.0. Describes how the new features meet the needs of different levels of users introduces selected features of Access 2.0 in a 'test drive' compares Access to other Microsoft products 03/29/94 Guide to specific locations in the Access 2.0 manuals and help system covering the most frequently asked questions about reports. 05/05/94 Access table in the form of a report to be printed - lists many features and the menus or buttons to click to get them. 04/20/94 Word for Windows document provides an introduction to the Microsoft Jet Database Engine and the advanced relational database engine built into Microsoft Access and Visual Basic. For the user who wishes to see how data is managed within the products. 04/06/94 Press release describing the Access Solutions Pack. Detailed information of the four applications included in the package: Sales manager, Asset Tracker, Registration Desk, Service Desk. 04/12/94 Access 2.0 contains a new Jet Database Engine which cannot be directly accessed by Visual Basic 3.0. This document explains the use of the VB 3.0 Compatibility Layer to allow VB 3 to access the Jet 2.0 engine. 03/28/94 Contains the press release and one page fact sheet for the Microsoft Access Developer's Toolkit. Describes the run-time version of Access, Setup Wizard, creating custom Wizards, sample OLE controls. 08/22/94 All Microsoft Knowledgebase articles (as of date of file) compiled in Windows Help format. Version for Access 2.x. Not on diskette library (too big). 06/10/94 Microsoft Access Naming Conventions article as published Page No. 17 12/01/94 PD/Shareware Products in Library Release Date Product Description in the August 1994 issue of Smart Access from Pinnacle Publishing. 06/01/94 List of available books about Access 2.0. Word for Windows 6.0 format and ASCII comma-separated format. 06/01/94 Magazine in Windows Help format concerning Access. Contains reviews of commercial and shareware products, Access Tips and Tricks, list of available shareware products. 08/31/94 Document highlights the differences between RJET 1 and RJET 2 as described in the Jet Database Engine ODBC Connectivity White Paper. Word for Windows 6.0 document. 08/22/94 Windows Help file contains tips and bug reports about Visual Basic for Applications, direct from Microsoft. 08/21/94 Errata sheet for "Access 2 Power Programming" by Chris St. Valentine, published by Que Books, ISBN 1-56529-763-6. 08/12/94 Document describes sources of information about the most frequently asked questions about queries. Includes list of references in the Access user's guides, the Access online Help, and KnowledgeBase articles. 08/11/94 List of 829 programming topics taken from the Access 2.0 online Help. Also includes a sample union select query to parse the different topic types (actions, properties, methods). 12/16/93 Magazine in Windows Help format concerning Access. Contains reviews of commercial and shareware products, Access Tips and Tricks, and list of available shareware products. 11/02/94 Word 6.0 and Write document written by a Jet program manager contains information on Rushmore as implemented in Access Jet 2.0, and benchmarks on query performance in Access 1.x and 2.0. 11/01/94 Not sold or supported by the author. Frequently asked questions about Access 2.0. Includes comparisons to other databases, Access Basic tips, tips on all aspects of Access. See ACCFAQ for tips on Access 1.x, still applicable to 2.0. 10/28/94 Access add-in application that will create an Access table with all Access error codes and their corresponding text. Also provides a simple lookup form for finding a specific code or string of characters. 10/18/94 Slideshow and Windows Help demo of HelpBreeze. HelpBreeze turns Word for Windows into a complete integrated environment for developing Windows Help files. Now includes the Topic Wizard which automatically structures and formats help files. 10/18/94 Press release for the Microsoft Access Upsizing Tools, an add-in product for Access 2.0. These tools allow converting an Access 2.0 database to a Microsoft SQL server-based database. 10/13/94 Access 2.0 database of over 3700 computer industry vendors. Names, phones, BBS numbers, tech support numbers. Searches on "name" field or "comments" field. Has "Preferred Vendor" selection for searching only your Page No. 18 12/01/94 PD/Shareware Products in Library Release Date Product Description vendors. 09/30/94 How to make Access play any wave file by using the SndPlaySound function in Windows MMSYSTEM.DLL. 09/07/94 Article in Word 6 format - Using the Database Window and Other Notes. Comments on handling windows in Access. ** Type Macros/Modules 02/13/93 Includes the function ElapsedBDays(), which allows you to find the number of business days between two dates, and a form displaying its use. Also includes a database for listing holidays which are to be excluded from the list of business days. 12/30/92 This is an example Access database that demonstrates retrieving information from the clipboard under program control, using several Windows API functions. 02/04/93 Sample database executes an Access Macro (DDE interface) which executes a module (ShellApps). Uses Word to open a new document, open the specified database, then table, establishes and updates the Bookmark, executes WordBasic to update the document! 03/10/93 An example of how to determine is a shelled process has been terminated when used with the Shell() function. 02/10/93 Sample database uses an Access macro to execute a module "SMAPI SendMessage". This calls several MAPI functions which will prompt the user to mail if they are not already logged on. For Windows for Workgroups. 08/31/93 Soundex takes a surname string and returns a 4-digit string representing the Russell Soundex code. 01/11/93 A function which spells out numbers for printing on checks. 03/05/93 Seven string functions useful to programmers. GetTokens tokenizes a string InitCaps capitalizes every first letter Proper capitalizes first letters and converts all others to lowercase Replace RInstr StrCount StrRev. Number to Roman number convers. 12/30/92 DLL to add a background timer capability to an application. 02/22/93 How to implement a timer control using Access Basic. 03/07/93 Windows 3.1 API function declarations as an Access MDB database. The author advises that this preliminary code may be more hindrance than help for new developers. 03/12/93 Simple database shows three different ways of playing WAV sounds in Access. Through the common file open dialog box storing the path in a table storing the WAV in a table. 10/13/92 Sample wedding mailing list. Demonstrates use of two overlaid command buttons to toggle between data entry and show all records mode. Includes pop-up print menu. All coding done with macros. Page No. 19 12/01/94 PD/Shareware Products in Library Release Date Product Description 01/31/93 Adds five functions. Return a specific word within a string, counting from beginning or end change to lower case except for first char of first word or every word. Access Basic code. 01/07/93 Text lists some available functions that can be used by Access Basic to generate new forms, reports, and controls. 01/08/93 How to create and debug an Access basic library using the undocumented functions CreateForm() and CreateReport() CreateControl() and CreateReportControl() DeleteControl(), DeleteReportControl(), and CreateGroupLEVEL(). 02/25/93 Example database created using only macros. Includes examples of using listbox to find records, as well as letterkey lookup (taken from NWIND). 05/04/93 Version of TIMERDLL.DLL (file TIMER.ZIP) modified by Bob Denny. Supports up to eight timers, each with its own user-defined macro, to run at each interval. Includes demo Access database with three timers. 04/01/93 Access Basic module functions to convert numeric currency amounts into words. 05/27/93 Compact popup calendar modules to set dates on forms or tables or queries. 05/30/93 Demo of how to display records for the user to browse and double-click to edit. Demonstrates use of the OPENFORM macro action's 'where' parameter. 04/06/93 Demonstrates how to use Windows Common Dialog GetOpenFileName() and GetSaveFileName() API functions. The code resides in three modules and are standalone when included with the Declarations and constants. 05/31/93 Subroutine to increment dates on bank checks by 28 or 30 days. 01/27/93 DLL for Access Basic to programatically manipulate table definitions and data relationships. Allows creation of tables with Access Basic. 03/03/93 DLL for Access Basic to programatically manipulate table definitions and data relationships. Allows creation of tables with Access Basic. For Access 1.1. 05/24/93 Sample MDB shows how to display Novell Network User Name within Access. 11/30/93 Simple method for user to make elaborate queries on all fields in a table by clicking the mouse. Uses two listboxes with Add and Delete buttons to make selection of items to query. Generates SQL lines which can be passed to Access filters. 06/01/93 Phonebook with modules to find a record from a combo box, requery the database while retaining the current record, and a routine to dial a phone from a field. 06/14/93 Demonstrates how to link two subforms using macros and unbound controls. 05/15/93 Simple database with Access Basic module called "System Information" containing FreeMemory, FreeResources, WinCoprocessor, WinMode functions. Page No. 20 12/01/94 PD/Shareware Products in Library Release Date Product Description 06/02/93 Routine shows the benefits of using the 'visible' property on a form, referring to the hidden form to filter records, and create a report. 05/06/93 Small database shows a few ways to play and store WAV files with Access and a sample registration routine, in case you wish to distribute your application as shareware. An updated (7-9-93) copy is available on CompuServe and from the author for $5. 07/23/93 Access database of error codes for version 1.1. 08/12/93 DLL contains the following functions: GetFileSize GetFileDateTime GetDiskFree DosFindFirst DosFindNext ConvertDosTime. Includes C source. 08/20/93 Form and code for a progress meter which gives the user a graphic indication of a lengthy operation. 08/06/93 Complete naming convention system for Access. 08/17/93 Database demonstrates how to remove the System menu and Resize icons from the Access menu bar when a form is maximized. 09/01/93 Access Basic function converts a phrase from English into Pig Latin. 08/05/93 Spell-Rite module helps with spelling of control names, filed names, and object names. Lists every object in your database. Event-Finder module helps locate events on a form or report, to track behavior of macros and modules. 10/10/93 Report, macro, and Basic routine for printing macro code from Access 1.0 and 1.1 applications. 09/29/93 Shoes how to display announcements on-screen without halting program execution, optionally keeping a log file of all displayed announcements. 11/06/93 A method of moving to a specified record using a combo box selection. The combo box is bound directly to a field which identifies the record being selected. 11/02/93 Calculates working days between two dates in any current working year using Access Date functions and an Observed Holidays table. 09/17/93 Event scheduler preprograms times at which Access Basic functions are to be called. 09/29/93 European modification of popup calendar originally by Gerry Kerr. Includes week number and start of week on Monday. 01/18/94 DLL allows Access Basic modules to write and read .INI files directly, by giving the section, entry, and ini filename. Sample module included. 01/05/94 MDB database contains a routine to convert an MS Access Import Spec to an Access Basic or Visual Basic code routine to read from a flat file, parse the fields, and output to a table. 12/29/93 Function which tests to be certain that a control on a Form or Subform has a Value. If not, returns FALSE, if so, returns TRUE. Page No. 21 12/01/94 PD/Shareware Products in Library Release Date Product Description 12/29/93 Access Basic module to ease the process of field-based entry. Allows data entry operator to type in part or all of a name in a control then call this module to break the name into parts: Prefix, first, Middle, Last, and Suffix. 12/12/93 Visual Basic module to take a string from a text box (or anywhere) and send it to the printer so that it will all print, wrapping at the word breaks as delimited by spaces. 12/03/93 Access Basic function which accepts a Variant value, returns a number rounded to a certain number of decimal places. Forces Access to round up when confronted with a value ending in "5". 10/07/93 Small utility program which makes it easy to switch between different Access startup configurations. It works by setting the SystemDB setting in the MSACCESS.INI file before launching MSACCESS.EXE. This lets you easily maintain various workgroup configs. 02/24/94 Music sequence game using WAV files. Snippets of a song are accessed by pressing Play buttons user tries to recreate the original order to "win" applause. Requires sound card or WAV driver. 02/24/94 Prints Windows Help and extracts plain text from Windows Help files. Can also drive the Windows Help engine to print the complete Windows Help File or a part of it. 01/27/94 Timer package to start and stop any number of timers within Access. Access Basic code, no DLLs. Each timer calls and Access Basic function when its timer count expires. 04/13/94 Access Basic module functions to convert numeric currency amounts into words. Improved from original CHKPRT routine. Allows changing the format of the output string. 03/30/94 Function calculates the number of elapsed days, the number of Monday through Saturday days, or the number of Sunday only days over a given time period. 05/03/94 Wizard helps to create better looking message boxes. Has the ability to generate full message box related code with full constants and return values. 04/04/94 Access 2.0 database containing a system information form that shows free memory, GDI and user heap space, video resolution, etc. Good examples of code behind forms, timer usage, run-time settable properties. 04/20/94 Calculates the first legal funding date for a home mortgage, given the closing date of the loan. Functions illustrate several tricks involving date manipulation. 03/26/94 Demonstrates calling a general purpose RunTriggers(myEvent) function from every event on every form and letting the Triggers table handle what needs to be done. This allows zero, one, or more statements to be executed on any event. 03/14/94 Contains a module "Text" which has one function called "Proper". Changes entry in a text box to capitalize the first letter of each word. 07/03/94 Collection of over 30 of the most used Windows API functions for Visual Basic for Applications. Performance Page No. 22 12/01/94 PD/Shareware Products in Library Release Date Product Description timing, get all fonts with one call, millisecond stopwatch, version information and more. Working demo DLL. 06/14/94 Two functions to fill a listbox with database objects. The use of these two functions eliminates the need for a table of report names, form names, etc. Documented Access Basic code. 06/13/94 Modified version of CMMDLG. Uses unique Type and Function declares. Commented Access Basic module. 06/06/94 OC1016.DLL, necessary for using OLE Custom Controls (OCX files). Includes installation instructions and utilities. 06/04/94 One line function, included on main form, accepts a value and the number of decimals and returns the rounded value. A negative number will return an integer value. 09/07/94 Access Basic module provides check digit verification for the following order code numbers: Hardware Wholesalers Inc., True Value, Ace Hardware, Paint Sundries Supply, UPC-A, EAN-13. Includes function to expand UPC-E codes to UPC-A. 09/04/94 Seven quick steps to add a clock to any Access form. Demo inlcuded. 08/26/94 Standard Windows Recorder Macro - quickly inserts generic error trapping into any Access sub procedure. 08/26/94 LZCopyFile function similar to the FileCopy function included in Visual Basic. Uses only calls to LZEXPAND.DLL that is supplied with Windows. 08/23/94 Demonstration of assigning and testing checksum numbers. Module code is behind the form. 08/16/94 GetToken function written in Visual Basic for Applications/Access Basic. Faster than a DLL because it implements pointers with static variables. 08/15/94 Program will take a data field that you specify and format the data to Code 39 Bar Code format. It adds the start and stop characters, eliminates spaces, calculates the check digit, and can format for Long Code 39. 08/07/94 MsgBox Wizard supports multiline messages and allows for embedding fields/expressions/functions within the body of the message. Uses Code Behind Forms and several forms of code generation. 08/02/94 Two functions that return the date of the first Monday for a given month and year. Can easily be changed for other days of the week. 03/23/94 Function accepts a variant value (n) and a number (d) and converts multiplace decimal numbers. Returns the number (n) formatted to (d) decimal places. 05/25/94 Demo for accessing Windows 3.1 openFile, SaveFile, FontSelect, Print, and PrintSteup dialog boxes, based on Visual Basic code by Costas Kitsos and L.J. Johnson. 10/25/94 Internal INI file system - a set of two tables and four functions that allow saving application information and user preferences without writing to an external INI file. 10/24/94 Collection of Access Basic functions that allow Access Basic strings to be encrypted and decrypted. 10/19/94 Demonstrates a simple way to detect idle time when Page No. 23 12/01/94 PD/Shareware Products in Library Release Date Product Description running an aplication. 09/27/94 Access basic function to calculate the fiscal month/year for any given calendar date. For example, specifying 7/15/94# might return a value of 1/1/95# to indicate the beginning of the fiscal year. ** Type Multi-User/Network 03/27/93 Adds phone dialing capability to the PIM that ships with Access. A simple routine that demonstrates the Windows API calls required to dial a phone. 06/21/94 After using the Access Security Wizard, adding additional users is a tedious manual process. This Wizard automates the process of assigning additional read, read/write, or full privileges. 06/24/94 Windows-hosted BBS based on Access and Procomm Plus for Windows (required). Offers file transfer from different file areas, messages, user security levels, and multi-field search on Access tables. 04/24/94 Demonstrates an indirect method to access security information from Access Basic code. Program illustrates the use of four forms to validate users in four different security groups. 08/09/94 Three functions: WriteSysLog - writes current time/date and user to a table UserGroup - returns True or False after checking whether a user belongs in a particular group youBelongTo - pops up a message telling a user which groups he belongs to. 11/07/94 Sample database shows how to send faxes, send mail, receive mail, and view message received by the database. Send faxes to individual or table of users. Requires Windows for Workgroups. 11/04/94 Multisuser forms demonstrate how to change the record source of a form on the fly how to bring up a form in browse mode and toggle between Browse, Edit, and Add modes. 10/26/94 Permission Manager shows in one dialog all the permissions of a specific user for a specific object. The user's own permissions are shown as well as the permissions of all groups he belongs to. German prompts, translated in documentation. 09/30/94 Gives extra security over normal Access permissions. Can perform multiple selections. Allows preventing the "Read design" option from being selected when a user or group has full data access. 09/16/94 Modifications for two of the Access 2.0 Wizards, which allows some of the wizards to be used in multi-user environments so more than one user can use the same wizard at the same time. NOT supported by Microsoft. 09/16/94 This application allows you to modify your SETUP.ATF to create your own custom setup routines for your Access Developer's Toolkit application. NOT supported by Microsoft. Page No. 24 12/01/94 PD/Shareware Products in Library Release Date Product Description 08/22/94 Improved version of the Access 2.0 Security Wizard. It is now possible to set the grants of each container individual, not only remove all grants from all selected objects. Removes the problem with the original Wizard on empty containers. ** Type OLE/DDE 01/01/93 Microsoft Word template to demonstrate Access as a DDE server to Word via Wordbasic. The macro requests Access's supported DDE Topics and Items. It also extracts Data and Fields from tables and Queries. 12/23/92 Excel macro, and example of using Excel to send a macro name to Access via DDE. The macro checks a form which contains DDE links back to Excel to provide parameters to a query. 01/27/93 Example of using DDE with Word and Access to create a Print Merge. 01/02/93 An Excel macro which uses DDE to transfer some or all Access database records into a worksheet. Access is the DDE server. 12/15/92 Database includes and example of inserting new OLE objects under program control. 03/19/93 DLL allows Access developers to programatically embed OLE objects from files into Access forms. MDB included which demonstrates its use. 12/15/92 From VB different commands are sent to Access. Access is told to execute an SQL string passed by VB and return first. next rows, execute a macro, execute a query, return field names of table. Also example of Access peeking and poking to VB. 05/21/93 Example of using DDE to poke the information from the current record on a form to Word for Windows. 04/13/93 Document manager using OLE object and fax DDE demos. Also contains examples of using Access as a DDE server and client to Word for Windows for print merging. 04/13/93 Source code for Visual Basic and Access Basic demonstrates for a VB-grid can be copied to an Access table. If the table does not exist, it will be created. 05/25/93 Database contains example of copying a graph object to the Windows Clipboard using a macro. 09/02/93 Update to the Oracle ODBC driver for Access 1.1. Removes 2000 character limit for SQL statements. Instructions contained in README file. 12/12/93 Adds phone dialing function using DDE. 02/23/94 Utilities to create or add definitions or fields to existing Btrieve databases for use with Access. 02/07/94 Everything needed to create/maintain/view DDF files for your Btrieve tables using Access of Visual Basic 3.0. Sample programs and documentation. 09/06/94 Shows the interaction between your application and the ODBC API with no modifications to your existing program. Shows the following information: parameters before and after the call, return value, pointer validation, and Page No. 25 12/01/94 PD/Shareware Products in Library Release Date Product Description more. 10/12/94 An example of how to do OLE Automation from an Access form to print a Word document that is based on a Template. ** Type Printing 03/19/93 Access Basic function to generate Postnet Bar Codes. Requires ZIPBAR (included in this collection). 12/12/93 Contains a shareware TrueType font that creates POSTNET bar codes for ZIP codes. A utility to calculate the check digit and FIM bars as TIFFs is included. 05/26/93 Code and example form to display how to change printers at run time. Uses the previously undocumented prtDevNames property of reports and forms to control the destination of the object. Provides functionality other wise difficult to control. 08/02/93 For pre-2.0 Access users. Code to select a printer, preview a report, or direct the report to fax, with example. 10/01/93 Barcode 3 of 9 function using native graphics/line draw methods instead of a dedicated font. 01/21/94 Documentation for the PrtDevMode and PrtDevNames properties, which sets or returns the device mode information specified for a datasheet, form, report, or module. 11/18/94 DLL that lets you change the default printer from within Access without having to use the control panel. Also lets you open the printer setup dialog box for any installed printer. ** Type Program Utility 05/28/92 Creates a screen grid with choices of background and foreground colors, then replaces Windows wallpaper with that grid. Shows limits of different monitor resolutions. Registered version adds features. 11/14/92 Sample code shows how to make VB forms device independent for the screen. Arrange your controls in code to achieve the same proportional look regardless of the resolution or screen font DPI. 08/13/91 Augments the standard 'Load' and 'Run' of WIN.INI with an easily altered list of startup applications. Intended for persons who frequently modify their WIN.INI. Written in Visual Basic, although source is not included. 04/12/93 Point and click interface for finding the right dir and backup for your data on the network. Easy for end-users. Later (2.0c) version includes check for archived flags and 3D controls. Requires VBRUN300.DLL. ** Type Programming 04/05/93 Beta version. Online reference to API calls including the Windows multimedia library, MMSYSTEM.DLL. Requires VBRUN200.DLL. An enhanced, 4.0 version for $10 will be available from the author in August. See file AHDAT.ZIP for updated data files. Page No. 26 12/01/94 PD/Shareware Products in Library Release Date Product Description 02/03/93 Educational programming tool. Point and click to build simple geometric shapes or enter simple commands directly. All commands are saved in an editable text box. Source code included. 04/08/93 Online reference to API calls including the Windows multimedia library, MMSYSTEM.DLL. New data files for file AH30.ZIP. Requires VBRUN200.DLL. An enhanced, 4.0 version for $10 will be available from the author in August. ** Type Queries 03/18/93 Example query allows for partial matches to be found. 01/26/93 Example of querying the underlying dynaset using a form where the user can enter values for each and every field, or none at all to return all fields. Uses macros and queries to drive the process. 03/11/93 Library database that implements a simple query-by-form facility. Creates a query form based on any data form. The user can enter criteria in the query form, then press a button that opens the data form with the selected records. 03/12/93 Sample database shows techniques for adding a null choice to list boxes/combo boxes. Also shows how to add separators to these lists. Uses only Queries - no Basic code. 08/17/93 Database demonstrates a query which filters records by a lower and an upper parameter. 07/05/93 Access Basic function creates a Query that will display all the Relationships between Access Tables. 09/24/93 Provides a "Find and Replace" function for Queries, Forms, Reports, and Macros. 10/28/93 Example of a query where the user enters part of a first and last name, and a query collects the matching records. A list box then opens for the user to select the correct name. 10/21/93 In place of normal query-by-example queries, this MakeFindClient() function looks at a Query By Form form and creates an SQL string based on the non-null fields. 01/19/94 Query-by-form interface that allows users to create custom reports without using the Access Query tool. Steps users through the process of choosing fields, setting criteria, then uses the Access Report Wizard to layout the report. 12/23/93 Tool for timing the execution of queries for performance tuning. Automatically loads all queries into a listbox. Select a query and it runs, reports the execution time upon completion and records the results in a table. 12/11/93 Database demonstrates one way to highlight, select, and identify multiple records when using continuous forms. 12/31/93 Sample MDB shows how to speed up some queries by a factor of 10 or more (or slow them down by the same factor). Module source code. 06/21/94 Query Builder module adds ad-hoc query capabilities to simplified databases. Lists all tables and queries, lets Page No. 27 12/01/94 PD/Shareware Products in Library Release Date Product Description user select columns, criteria, sorting, etc. 06/30/94 A mini application that helps make those tough decisions. Modeled after the famous Magic 8 Ball toy. 06/03/94 Demonstrates sorting records in tabular continuous form by any column. Uses toggle buttons within an option group to serve as column headers. When the user clicks on the button, the records are sorted by the column heading. 08/29/94 Access Basic function: CrossTab query with implicit parameters. Use this function to use a form's control as criteria in a Cross Tab query. 08/16/94 Windows Write file describes "How to Create a Cross Tab Query which uses Implicit Parameters". ** Type Reference 06/14/93 Corrections and updates for the book 'PC Magazine Visual Basic Programmer's Guide to the Windows API'. Includes updates for Visual Basic 3.0. ** Type Reports 11/16/92 Text article describes how to create a label that will print at the top of each page when a group of data spans more than one page. 12/31/92 Simple example uses a query to print multiple labels per record. 11/25/92 DLL allows printing reports to an output file using Access Basic. 09/29/93 Simple function to display or print a DOS text file. 10/17/93 Shows how to launch reports from macros. 11/12/92 Module to add saving report output to a file. Output to ASCII, RTF, or BIFF formats. 05/29/94 Database demonstrates two methods of selecting reports for printing. First method is having the names in a drop down box, second method uses a rocker switch to show and hide the selection form. 08/16/94 Demonstrates a way to make mailing labels with fields that can shrink with a graphic on the left side, by using a report with a subreport. 10/24/94 Program demonstrates a mirroring technique, where a Form is used with an almost identical report to allow runtime customization of the report. The user can move object on the form/report with drag/drop the changed report is saved or remembered. 10/13/94 Form lists all queries and reports in the current database in a listbox that can be selected for viewing or printing. No tables are used or created. ** Type Security 10/07/93 Implements security. Adds proper permissions to the database. Not supported by Microsoft. For Access 1.1 only. 10/20/93 Examples of using SendKeys, to set up or remove user security from Access. 06/02/94 Implements security. Adds proper permissions to the database. File contains Access 2.0 Security Wizard and Page No. 28 12/01/94 PD/Shareware Products in Library Release Date Product Description "Microsoft Access 2.0 Security Whitepaper" documentation. For Access 2.0 only. 11/18/94 Shows in one dialog all permissions of a specific user for a specific object. User's permissions and all the permissions of the groups they belong to are displayed. You can also change permissions in the same dialog box for user and their groups. ** Type Setup 12/28/92 How to gain performance improvements on a 4 meg machine. 01/26/93 Text file containing sample code for changing certain printer settings. 05/10/91 Visual Basic 1.0 runtime. Required for some utilities. Install in \WINDOWS\SYSTEM directory. 10/21/92 Visual Basic 2.0 runtime. Required for some utilities. Install in \WINDOWS\SYSTEM directory. 04/28/93 Visual Basic 3.0 runtime. Required for some utilities. Install in \WINDOWS\SYSTEM directory. 05/10/93 Customizable menu that allows the programmer or network user to change SYSTEM.MDAs. The various SYSTEM.MDA files can be given expanded descriptions on the menu. 05/15/93 Database that helps maintain the table of label sizes that Access Mailing Label Wizard uses. A 6-27-93 version with some minor changes is available on CompuServe in the MSACCESS forum. 07/27/93 Visual Basic 3.0 runtime. Required for some utilities. Install in \WINDOWS\SYSTEM directory. Improved "301" version runs correctly on 286 systems and under Windows NT. 07/27/93 Updated XBS110.DLL fixes several bugs in accessing Xbase and FoxPro files. 01/17/94 Utility to start Access and load the file specified in the edit box. Remembers the last used database as the default. Works with retail or run-time Access. 06/15/94 Enhanced Setup Wizard. Features: you can specify a SYSTEM.MDA and name it accordingly automatically creates a compact/repair Program Manager icon for all files ending in MDA or DAT. 10/24/94 Fix for a problem in the Access 2.0 Developer's Toolkit which causes the failure of runtime setups. 10/14/94 Custom install of Access on networks. Create scripts to run Setup automatically. Can only be used after completing the Administartive Setup of Access on a network server. NOT supported by Microsoft use AS-IS or modify. 08/25/94 Sample database allows you to create multiple Program Manager groups as well as multiple Program items in these groups. For use with the Access Developer's Toolkit. NOT supported by Microsoft. ** Type SQL Server/ODBC 02/03/93 Provides SQL support beyond normal Access linked tables. Gives the Access programmer access to executing row Page No. 29 12/01/94 PD/Shareware Products in Library Release Date Product Description returning stored procedures, remote DDL and back end specific SQL. 06/14/93 Replaces SYBASE.SQL and all other INSTCAT.SQL files. This file contains the INSTCAT.SQL file that is compatible with both MS SQL Server and SYBASE SQL Servers. 03/12/93 Examples of a technique for faking an SQL UNION. This technique uses a pure Query. 05/05/93 Provides SQL support beyond normal Access linked tables. Gives the Access programmer access to executing row returning stored procedures, remote DDL and back end specific SQL. For Access 1.1. 06/14/93 Replaces SYBASE.SQL and all other INSTCAT.SQL files. This file contains the INSTCAT.SQL file that is compatible with both MS SQL Server and SYBASE SQL Servers. For Access 1.1. 09/01/94 Time-limited sample version of SQL Sniffer. Views a trace of all most used W3DBLIB.DLL calls with just a click of the mouse. 09/01/94 Time-limited sample version of ODBC Inspector 1.1 application. Assists developers in producing Windows based front-ends using ODBC. Traces all ODBC calls simultaneously. 03/05/94 When structural information about an ODBC-attached objects changes, it is necessary to detach and reattach the object for Access to be aware of the changes. This function "jwnODBCReattach" automatically handles this condition. 08/11/94 RTF document describes how to use Access 2.0 ODBC without having all of Access 2.0 installed. 10/20/94 SQL Wizard and report forms. Undocumented. 01/13/94 Sample version of SQL Sniffer. Views a trace of all most used W3DBLIB.DLL calls with just a click of the mouse. ** Type Suggestions/Mktg 04/21/93 Microsoft Whitepaper, "Choosing the Right Database Tools", discusses the differences between Microsoft's Access and FoxPro products. 05/04/93 Windows Help file which describes the changes from Access 1.0 to 1.1. Also includes common Questions and Answers. 08/03/93 Press release: Microsoft Sweeps NSTL Comparison of Multiuser Databases for Windows. ** Type Tables 02/25/93 Example database shows how to do list functions based on RecordSets (Dynasets and Snapshots). Also shows various techniques for working with lists, 03/18/93 An alternate example to "Finding a Record by Selecting a Value from a List" presented on page 547 of the Access User's Guide. This example uses Access Basic and its Bookmark property. 07/06/93 Access normally "hard-codes" the location of attached tables into the local database. This file shows a technique which allows attaching the tables dynamically Page No. 30 12/01/94 PD/Shareware Products in Library Release Date Product Description when the database is first opened. 08/20/93 Database of states and area codes choose area code to find the state or choose state to find its area codes. 07/07/93 Sample application for any organization that tracks memberships. Includes user menu, tight query, many-to-many relationships, etc. Featured in Access Advisor magazine, August 1993. 07/12/93 Database shows the number one song for any week between 1955 and 1989. 12/18/93 MDB file containing a single table - the nations of the world. Extracted from CIA World Fact books 1991 and 1992. 02/11/94 Two functions and a form demonstrating filling lists. This technique works for List Boxes and Combo Boxes. This example fills one Combo Box with table info and another with field info. 10/30/93 Database of hard drive specifications, repair facilities, and hard drive manufacturer's BBSes. 04/25/94 Simple program illustrates how to perform a cross tabulation in a report without using a cross tab query. The program combines a list of holidays with a list of days in the year to produce a simple two page calendar for a year. 06/30/94 Wizard creates code for a subroutine to create a table that is a "close" copy of a table selected as a template. This is meant to provide a short cut when a table needs to be made by code, e.g. a temporary table or in a database created by code. 09/14/94 Access add-in allows you to attach and detach from as many tables and as many databases as you wish. Simpler than the Attachment Manager. Supports only Access and Btrieve databases in this release. 09/14/94 When it is desirable to have an Access counter field that begins at a number different than 1, or to change the next value from the current setting, this add-in provides a form to automate the task. 09/11/94 Function to reattach tables into files located in the same directory as the code database file. This means you can just copy matching code and table database files from one directory to another and call this function. 11/18/94 Reads an MS-Access MDB file (version 1 or 2) or any ODBC source and creates Visual Basic, MS-Access 2 or SQL code to recreate that database. ** Type Tutorial 01/04/93 Self Study Guide for Access, in Word format. 04/14/93 Self-study instructor guide text files in Microsoft Word and WordPerfect format. Covers design, forms, macros, modules, queries, reports, tables. 03/31/94 Two Word for Windows documents: Introduction to Relational Database Design Access 2.0 Building Blocks. From Tech*Ed 94. Sample database included in file BBDATA. Page No. 31 12/01/94 PD/Shareware Products in Library Release Date Product Description 03/31/94 Two Word for Windows documents from Tech*Ed 94: Advanced Queries Using Access Database Optimization Techniques. 03/31/94 Word for Windows document from Tech*Ed 94: Overview of Forms in Microsoft Access. 03/31/94 Word for Windows document from Tech*Ed 94: Database Publishing: Creating Reports Using Microsoft Access. 03/31/94 Word for Windows document from Tech*Ed 94: A Comprehensive Look at Macros in Microsoft Access. 03/31/94 Four Word for Windows documents from Tech*Ed 94: Introduction to Access Basic Code Writing Wizards for Microsoft Access Advanced Access Basic Advanced Data Access Techniques in Access Basic. 03/31/94 Word for Windows document from Tech*Ed 94: Creating Multiuser Applications in Microsoft Access. 03/31/94 Word for Windows document from Tech*Ed 94: Building DDE and OLE Applications Using Microsoft Access. 03/31/94 Word for Windows document from Tech*Ed 94: Accessing External Data Using Microsoft Access. 03/31/94 Word for Windows document from Tech*Ed 94: Implementing Security in Microsoft Access 2.0. 03/31/94 Two Word for Windows documents from Tech*Ed 94: Using Microsoft Access and Visual Basic for Flexible Applications Building Advanced Applications with Microsoft Access. 04/20/94 Word for Windows document from Tech*Ed 94: Converting Applications from Microsoft Access 1.1 to 2.0. 03/31/94 Windows Write document detailing the hundreds of major and minor enhancements made to Access 2.0. Many screen shots and details not easily found in the manuals. 08/01/94 Sample databases used in Microsoft TechEd session AC211. See file TECH01 for documentation.